/**
 * Created with IntelliJ IDEA.
 * Description:
 * User: 17655
 * Date: 2025-03-25
 * Time: 15:19
 */
public class test51 {
    /**
     * 请按照年龄(age)分组，查出不同组的平均分和人数，分数(score)低于60分的人不参与分组，
     * 某一年龄分组人数小于2，该年龄段不参与分组，请按照以上要求写出sql语句
     */

    // select age ,AVG(score) as average_num,COUNT(*) as number_of_people
    // from table where score >=60 group by age having count(*) >=2;
}
